PPS 2010  -- No filter Data retrived  error?

HI.,

      I need to retrive the Top 10 , Top 25 commodities for that over all comodities  in the filters  based on the Weeks i selected..

Please help me.

NONEMPTY

( TOPCOUNT({ [Dim Commodity].[Hierarchy].Members},3,[Measures].[Teu]))

-----------------------------------------------------------------

NONEMPTY

( TOPCOUNT({ [Dim Commodity].[Hierarchy].[ALL] },3,[Measures].[Teu]))

How to get top 25, Top 10 for the given Date Difference based on measure.

January 16th, 2013 1:52pm

Hi,

Please look into cascading filters

Here is an excellent post from Dan that should help you:

PerformancePoint 2010 Cascading

Free Windows Admin Tool Kit Click here and download it now
January 17th, 2013 8:07pm

Hi.,

     I am asking about the MDX qurey format need to passed in MDX query filter.

Kindly help me regarding that way..

January 18th, 2013 12:30pm

Create dynamic sets for Top 10 and/or Top 25 commodities and use that in report.
Free Windows Admin Tool Kit Click here and download it now
February 14th, 2013 10:23pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics